--ready
USE [whydb2012]
GO

DECLARE	@return_value int

EXEC	@return_value = [whydb2012].[P_Ready]
		@UserID = N'test',
		@RoomGUID = '35F6DDE4-ED96-4D75-9262-23704DE0BE0E',
		@operatortime = '2012-2-25'

SELECT	'Return Value' = @return_value

GO


--sit
USE [whydb2012]
GO

DECLARE	@return_value int

EXEC	@return_value = [whydb2012].[P_Sit]
		@UserID = N'test',
		@SeatID = 0,
		@RoomGUID = '35F6DDE4-ED96-4D75-9262-23704DE0BE0E',
		@operatortime = '2012-2-25'

SELECT	'Return Value' = @return_value

GO

--stand
USE [whydb2012]
GO

DECLARE	@return_value int

EXEC	@return_value = [whydb2012].[P_Stand]
		@UserID = N'test',
		@RoomGUID = '35F6DDE4-ED96-4D75-9262-23704DE0BE0E',
		@operatortime = '2012-2-25'

SELECT	'Return Value' = @return_value

GO

--
select * from tb_room

select * from TB_USER_ROOM_MAP

select * from whydb2012.TB_PLAY_RECORD

select * from whydb2012.TB_ROUND

--update TB_USER_ROOM_MAP set status=0

delete from TB_ROUND

delete from whydb2012.TB_PLAY_RECORD

update TB_USER_ROOM_MAP set status=0,leftcardid=null,seatid=-1,cardnum=0

update tb_room set gameprocessing=0,roundguid=null,playercount=0,watchercount=3

40,30,27,19,24,35,22,17,33,21,
47,37,55,2,8,5,14,31,48,20,
43,36,18,16,42,52,13,50,11,29,
15,3,4,54,10,38,23,9,12

select * from whydb2012.TB_CARD

rollback